/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_channel.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_CHANNEL
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_channel.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_CHANNEL::CTable_PPM_CHANNEL( )
 :NPCRecordSet( )
{
  setTableName( "PPM_CHANNEL" );
  prepareTable();
  prepareQuery();
 
  CHANNEL_ID.setField( "CHANNEL_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( CHANNEL_ID );
  makeKeyItem( CHANNEL_ID ); 
  CHANNEL_NAME.setField( "CHANNEL_NAME", DATA_CHAR, 50, 0 );
  makeTableItem( CHANNEL_NAME );
  CHANNEL_LEVEL_CD.setField( "CHANNEL_LEVEL_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( CHANNEL_LEVEL_CD );
  CHANNEL_TYPE_CD.setField( "CHANNEL_TYPE_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( CHANNEL_TYPE_CD );
  CHANNEL_SUBTYPE_CD.setField( "CHANNEL_SUBTYPE_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( CHANNEL_SUBTYPE_CD );
  STATUS_CD.setField( "STATUS_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( STATUS_CD );
}


CTable_PPM_CHANNEL::CTable_PPM_CHANNEL( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_CHANNEL" );
  prepareTable();
  prepareQuery();
 
  CHANNEL_ID.setField( "CHANNEL_ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( CHANNEL_ID );
  makeKeyItem( CHANNEL_ID ); 
  CHANNEL_NAME.setField( "CHANNEL_NAME", DATA_CHAR, 50, 0 );
  makeTableItem( CHANNEL_NAME );
  CHANNEL_LEVEL_CD.setField( "CHANNEL_LEVEL_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( CHANNEL_LEVEL_CD );
  CHANNEL_TYPE_CD.setField( "CHANNEL_TYPE_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( CHANNEL_TYPE_CD );
  CHANNEL_SUBTYPE_CD.setField( "CHANNEL_SUBTYPE_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( CHANNEL_SUBTYPE_CD );
  STATUS_CD.setField( "STATUS_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( STATUS_CD );
}

CTable_PPM_CHANNEL::~CTable_PPM_CHANNEL( )
{
    close();
}

